Supported Data Types
The following table shows the Google Cloud SQL for MySQL database target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.
For information on how to view the data type that is mapped from the source, see the section for the source endpoint you are using.
For additional information about Qlik Replicate data types, see Replicate data types.
Qlik Replicate data types | Google Cloud SQL for MySQL data types |
---|---|
BOOL |
BOOL |
BYTES |
If length is => 1 and =< 8095, then: VARBINARY (Length) If length is => 8096 and =< 65535, then: BLOB If length is => 65536 and =< 16777215, then: MEDIUMBLOB If length is => 16777216 and =< 2147483647, then: LONGBLOB |
DATE |
DATE |
TIME |
TIME |
DATETIME |
If scale is => 0 and =< 6, then: DECIMAL (p,s) If scale is => 7 and =< 12, then: VARCHAR (37) |
INT1 |
TINYINT |
INT2 |
SMALLINT |
INT4 |
INTEGER |
INT8 |
BIGINT |
NUMERIC |
If scale is => 0 and =< 30, then: DECIMAL (p,s) If scale is => 31 and =< 100, then: VARCHAR (45) |
REAL4 |
FLOAT |
REAL8 |
DOUBLE |
STRING |
If length is => 1 and =< 8095, then: VARCHAR (Length) If length is => 8096 and =< 65535, then: TEXT If length is => 65536 and =< 16777215, then: MEDIUMTEXT If length is => 16777216 and =< 2147483647, then: LONGTEXT |
UINT1 |
UNSIGNED TINYINT |
UINT2 |
UNSIGNED SMALLINT |
UINT4 |
UNSIGNED INTEGER |
UINT8 |
UNSIGNED BIGINT |
WSTRING |
If length is => 1 and =< 8095, then: VARCHAR (Length) If length is => 8096 and =< 65535, then: TEXT If length is => 65536 and =< 16777215, then: MEDIUMTEXT If length is => 16777216 and =< 2147483647, then: LONGTEXT |
BLOB |
When the Allow unlimited LOB size option is enabled:
When the Limit LOB size to option is enabled:
For information on limiting LOB size, see Target metadata. |
NCLOB |
When the Allow unlimited LOB size option is enabled:
When the Limit LOB size to option is enabled:
For information on limiting LOB size, see Target metadata. |
CLOB |
When the Allow unlimited LOB size option is enabled:
When the Limit LOB size to option is enabled:
For information on limiting LOB size, see Target metadata. |